SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570319 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570319 [ RunTime:0.004314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043423,426375,74248,359989,346247,444431,256525,111591,605596,791127,1022088,398238,657046,840390,24739,59433,361848,256305,204524,113801,365389,783247,562969,661900,287060,388391,293555,101317,595628,604932,251002,220876,949286,183804,802776,937932,253710,148142,278788,258684,3821,574569,90303,939298,876480,436133,625815,467559,201850,951208,1035571,868415,625639,363682,650703,1017670,791484,114825,930316,512735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]