SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514721 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514721 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902866,102789,326939,374382,430516,1035718,188646,661184,321715,1016862,110128,858539,177108,915022,361663,9438,277053,472530,1023997,769818,604570,59099,107056,876933,40295,563580,318033,296797,557797,1022546,252216,952223,57595,369884,1013698,457532,76519,118208,22875,317552,608153,820649,987139,519942,659697,979078,826771,407544,435204,615943,459154,576181,332260,7073,48311,605406,921133,636037,399444,491676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]