SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563791 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563791 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005395,61504,1004189,231526,263492,86463,972327,966597,377394,398997,433013,1045880,959748,240158,822680,58584,101240,572910,408114,661853,237073,456116,941898,252966,194713,814157,49582,444652,861740,384768,923526,206075,2085,108943,386909,893454,638317,287691,283282,93991,603167,541741,770551,11691,971314,63050,888225,401209,880809,361068,188461,580518,784505,955272,94369,720454,58299,279962,818992,811850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]