SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109936 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109936 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389823,561496,706201,454470,499690,70020,394182,879795,907515,240267,173866,69726,746313,341531,894181,640149,257231,116007,255424,1011569,251114,149782,98008,359272,195169,623320,999052,333878,961040,163473,735219,620502,63511,908385,565828,685416,80072,983912,867567,720435,621720,253629,175732,964155,501455,120292,1016145,943462,617120,1027266,460450,731727,367737,1024157,991543,900447,315368,26756,158049,432502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]