SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 257480 LIMIT 1 [ RunTime:0.005050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 257480 [ RunTime:0.004230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626636,291835,302742,120182,960879,575233,435207,656314,24740,199961,1001093,418227,676153,253109,526053,281208,987397,842422,662927,381579,523079,1021568,471191,489621,660824,301345,1010907,96391,258382,911083,460293,277496,242206,1004088,724683,551654,83064,791167,688960,750053,762997,161424,804090,31605,907962,574824,496995,633684,957022,564889,695007,143250,709851,716311,530896,398336,546457,312822,48751,737322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 257480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 257480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]