SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323328 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323328 [ RunTime:0.003431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375451,263494,305887,130861,190925,1025807,1039361,600586,129557,209833,1041116,766852,208549,736516,567446,851522,242851,594555,502242,370621,770382,748981,784100,999549,423435,66424,701941,798871,646548,844424,279709,517562,744786,652892,626454,948921,247025,909729,60802,313610,311030,224232,693453,264298,674861,709588,349672,489320,232318,278784,1047208,823335,568287,36346,53894,908009,543168,975045,497743,469308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001020s ]