SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036201 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036201 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31577,805088,366502,708936,475614,229393,750355,72108,53158,17627,105762,711936,912719,372827,680558,979124,25361,550763,45684,1046774,1026727,122280,851988,951904,984545,464323,1038182,845496,588128,669899,10656,358963,199081,580041,305593,545620,219575,40461,491941,46015,438035,16867,23499,641615,465018,145363,553814,886438,300354,897482,968917,772276,344235,112769,409067,587661,613520,476308,589588,898569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001412s ]