SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105266 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105266 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288085,783729,542701,789047,748443,511948,481686,450103,185729,50427,840411,722421,1005852,849129,172552,978565,786375,859306,87368,87828,668488,82475,298241,866573,593315,928843,63749,9704,160475,341998,253090,278029,108641,926877,82693,138485,562584,643539,890203,632818,569243,790104,82970,139088,189422,167218,57885,222634,610312,1028881,4498,584812,457329,984170,316976,181349,692437,122731,495642,558075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]