SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023530 LIMIT 1 [ RunTime:0.001572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023530 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028682,592361,207692,245408,574688,390659,415660,1010322,764614,1016111,981588,516960,47130,834797,813276,952893,382320,150606,1010496,368638,1038818,470629,497837,369041,307581,852597,115932,143346,393846,795122,182539,990078,906145,304952,208751,498960,933169,163099,796996,64752,579492,803042,526331,934832,119386,895006,795754,329399,205670,907821,312070,749298,855485,73910,281407,159519,718128,503627,929089,731932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]