SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 239591 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 239591 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71031,402404,66666,868077,569336,224129,487141,71512,134820,20993,1022914,886850,501306,694710,940015,909155,381237,270788,168306,1027898,719255,790631,910456,959552,484638,363238,980481,522433,413259,1021665,710083,730216,629545,369338,243694,6428,954335,912159,297836,930191,543396,934918,121604,367712,185642,520677,862643,39721,600484,553448,939351,522889,221834,540765,501251,357078,669107,334002,332209,653241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 239591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 239591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]