SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19483 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19483 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258151,152804,52363,155031,532410,376779,531561,610263,261230,693662,1005197,259914,61897,386304,331358,511967,984849,667081,927637,1032927,639,810606,989041,25744,296900,359070,141125,546965,429236,258116,602571,300455,206642,957456,662728,767582,781053,428356,1025972,909924,18690,1034160,293389,37462,797154,192154,227602,1008179,74424,393403,643553,52075,1024097,675321,293151,914210,751357,327490,398385,1016494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001731s ]