SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525448 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525448 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398545,266960,1048163,645933,1048634,249710,725974,217038,988407,772558,514048,748667,255190,429561,362430,868229,50503,558414,70115,379576,500451,776826,149564,595905,259202,294585,295338,939121,1043037,700350,508620,795417,639229,984266,930559,230565,846848,428618,140054,927208,785305,577044,194870,231967,126890,405672,30117,506950,776371,225494,859507,550876,65469,673904,541520,456971,777012,850567,630001,493716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001081s ]