SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685623 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685623 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238814,438654,430447,354356,962916,747267,342508,49060,254081,28573,403666,291565,850087,919827,814159,629106,924428,789126,523115,651823,567408,699779,678320,63076,304437,355225,1019119,286044,191585,140343,71244,323146,168418,842001,246623,503804,873583,364062,189233,172919,755174,760191,634508,819877,369603,595048,714293,393496,57980,880318,284952,775726,565398,255856,264891,220552,100166,780561,681212,919795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]