SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579853 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579853 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302111,975117,595087,222745,915655,281264,589584,384988,498914,968101,1012984,234548,188597,295284,1025606,441170,810249,554230,516352,357550,678201,766857,889331,186456,757348,396078,818272,253421,1016698,172038,633423,961821,930274,982232,199119,361670,674338,975684,643541,524841,991944,85738,498356,706658,1013649,308413,860186,911609,771417,491982,647609,390644,442256,89771,878165,631599,918601,151514,365958,115931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]