SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995810 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995810 [ RunTime:0.002377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499573,13098,561082,162240,788214,484729,783603,503806,244179,869599,1010367,655627,319681,297879,812084,952816,658210,865010,488006,1037423,1020911,725297,431466,768035,641162,296536,504890,997948,305402,481721,281406,44424,404869,90293,934969,335184,235089,989848,500091,641883,748848,153674,81299,117467,1042733,369257,788952,666681,941227,197720,290562,488616,709612,915010,263719,127257,1015681,312188,641861,777806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002577s ]