SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19546 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19546 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497570,313284,942877,845955,146212,238049,205182,987511,246580,747941,1043308,811015,732853,647887,700475,21311,91547,104347,34146,515248,12397,655365,138297,760181,461616,889673,312026,322060,1031915,290017,251362,153239,839010,678607,884167,987476,477693,389685,879473,434056,585480,549876,218046,531401,829809,785264,73974,241034,160629,237058,194669,320137,679801,403084,274234,727808,812507,576680,422883,883494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]