SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029450 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029450 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129124,49039,454962,366172,672922,101287,579946,801559,340938,432255,59341,298035,680723,387169,486721,430602,483644,132842,731886,103306,323286,365729,975303,949481,287367,287374,912022,137875,651061,900946,593358,465860,15540,307381,748945,794254,608306,451349,152772,109606,148147,628540,74236,276714,561157,15612,310153,1048848,635782,469253,589811,276620,252541,466320,710880,691456,1012883,47377,821378,66832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]