SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599791 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599791 [ RunTime:0.003655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370109,503051,188918,504773,909580,500569,514280,734075,105963,815490,848572,410075,413689,31671,271862,489018,561129,886499,803702,479868,73250,457315,251713,697431,730269,78524,698910,618385,19179,970625,85398,323272,57846,81521,832890,344090,458932,249224,239653,73392,699173,275423,232352,562522,936747,351539,475937,975291,824557,266653,434411,611343,335777,794741,438287,1005773,518036,178725,203377,785908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001050s ]