SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486183 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486183 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194098,662901,919338,168360,720600,595900,462668,1028365,510982,857576,547683,324047,20880,358317,19818,867047,555489,35918,812417,574460,322871,374801,82059,415916,98464,38265,219320,276345,641691,59911,55153,288740,610023,645625,101572,303482,596695,563851,962255,461637,317067,312413,767809,567447,345637,933859,708679,170289,640178,396855,166806,511462,511783,1023041,212282,114112,975480,297803,587063,25148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]