SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026765 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026765 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036408,518816,756280,102119,479805,612044,541411,620773,616279,430493,114957,231074,1024250,919876,984925,401062,235206,133076,1027137,536001,659291,366585,428232,72330,996521,305689,515144,276615,242726,965670,168619,825507,627820,199869,708394,1048078,265985,943526,714472,75764,833143,964616,717049,851985,810065,269383,1044392,611321,793713,555848,106644,1003864,702628,896709,790386,732705,546762,366407,193845,474917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]