SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533780 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533780 [ RunTime:0.004447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957383,176515,380159,1040399,3735,465400,276437,317953,252545,906928,1025530,820192,575876,98055,650202,591506,554217,282725,158828,219271,189635,501419,650266,147980,1008342,490270,657268,542241,535647,379414,542647,914800,765999,605896,245527,432129,368277,17422,802993,286772,154183,901569,309877,669245,583283,364979,6493,330490,57451,816735,773641,86549,163248,269332,365209,607912,199198,299559,814952,849084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]