SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514052 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514052 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198532,283672,540110,471868,772416,1009014,210467,861586,262919,766159,1042014,916927,819032,463027,987577,653174,167245,345092,471163,893418,137105,412776,774263,424515,649680,945375,366319,724074,834800,335266,935003,260026,790873,191016,111404,1047399,954222,419900,281620,841199,116085,328905,997904,435111,1021330,213326,904893,997393,483258,530013,265041,694656,844211,565583,717573,38331,139575,460035,421730,173744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]