SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300102 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300102 [ RunTime:0.004116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493557,1004960,762406,600783,784163,361005,233683,729808,299696,553031,621237,377396,299169,338061,591702,275265,847926,387677,795489,931102,640053,428517,356452,950265,384257,274673,8139,921998,982084,690019,374723,1016171,323184,660656,84487,343362,751627,6140,451257,332448,565400,730022,669788,461386,962167,429027,53661,253559,801485,192320,410599,242712,380697,196299,1002552,854274,933661,596821,49170,217659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]