SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034477 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034477 [ RunTime:0.004049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455195,553288,118275,54911,357298,865958,60191,410531,655330,703183,918054,278112,816410,427940,228285,795336,918202,802272,856481,771474,498378,344352,297862,462290,610016,963826,339388,82017,312424,454119,154008,256935,967814,462771,513462,1013484,710210,55176,222038,479532,310477,353861,960882,374684,817474,229908,598365,789647,722026,676838,219122,459590,881045,55447,716143,915113,1020704,346266,190764,679413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]