SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594423 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594423 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627919,486210,372573,711826,933732,112350,1042589,932129,362763,773026,206542,740728,540180,1009672,1029430,441800,1041798,296639,805643,192839,173327,224327,227768,706171,823866,556310,81476,126230,287815,252527,690357,67103,550789,566682,895216,273189,362203,362906,1020221,935819,1040363,819297,304334,260459,440178,1701,215742,240784,687075,927488,81691,555964,78060,70612,795766,598024,552921,950512,379609,890269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]