SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567809 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567809 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1939,347726,551745,570122,719191,475453,442116,999283,10457,423132,100485,636370,683981,497690,392494,696339,648186,814925,566044,214898,84215,322082,743302,577065,734785,776718,861817,526600,676878,225028,868963,782567,844427,777071,350746,323015,104800,318362,978155,338671,984301,486463,991263,522992,210975,262366,828906,350596,1007612,95678,500899,602951,645079,230485,309208,310174,953812,47483,833283,100087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]