SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254640 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254640 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996361,1048461,525403,921867,370851,943698,974625,762690,692034,984591,161636,767422,289994,337432,1019220,876720,711866,566201,1009265,720678,876777,745566,712029,12657,335461,982701,976192,812761,344375,771746,7348,472820,618407,757337,987670,545145,943460,270444,509677,39682,768387,170302,985429,439165,623005,572381,716549,753822,388956,187346,1000918,115686,742351,569257,372746,686976,15544,867434,490330,674336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]