SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42004 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42004 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385537,976297,1010969,834009,966518,21151,896678,176295,683117,934268,920339,529491,345093,403366,208369,500781,248157,524883,196896,514925,72991,561288,405731,214895,163904,4714,597203,158573,846422,897029,676577,944710,875641,125369,464991,690237,281334,919025,126860,112885,20068,297829,548691,985599,1041285,58938,275055,864096,551871,652702,28317,1040496,570228,831761,804699,199399,173567,297739,283444,1042163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]