SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108343 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108343 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201740,769191,284509,547426,655773,105793,790570,703343,105115,22773,622822,324159,280129,884553,153320,727024,591788,666371,890751,887544,706600,903892,583745,354220,1003326,247725,138019,226993,471555,101183,159477,962896,143425,398768,472103,7307,48405,356266,779986,315696,813294,802877,531330,987079,483334,811102,567598,386888,245038,343312,867110,215257,811941,524009,961867,902372,633634,749256,852847,1014910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]