SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267621 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267621 [ RunTime:0.004019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998812,633200,150263,302354,1025972,192805,789924,421521,1020240,329725,474858,737164,53589,700083,232941,235814,693937,389255,685989,952249,57714,511650,140707,606484,681770,784340,136756,944345,844872,739930,400280,391518,678915,228095,298466,626498,889185,945166,379879,575053,963308,319680,873620,133737,977293,171466,666280,688348,772381,680410,902931,228142,914493,259044,490408,527624,348431,524034,477982,500653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]