SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475505 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475505 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706087,781680,371346,672804,847912,807475,86149,198811,670482,748356,89269,968058,1027239,571413,242202,1016151,404607,387996,313679,987834,436883,955761,123428,731113,380961,462174,159411,289676,47666,714049,135167,114496,723079,303859,179327,150441,363995,321098,219749,92948,410964,258838,527846,992429,647627,614325,497634,775724,880601,626443,723539,137086,83680,40245,780975,478230,270715,22926,982628,902399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]