SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104320 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104320 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468533,457273,968980,634637,846044,1010612,876540,831523,26078,579578,1001066,796635,519552,863467,301589,869559,980932,107957,121043,37504,548577,443883,513950,768245,345860,510270,300480,618057,948495,668170,813792,798485,835961,617400,238854,175039,595421,277828,435187,289364,307218,48817,914442,443506,206483,443524,892974,789926,849267,200680,506278,349123,31657,772447,520218,404884,776077,126259,255318,624681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]