SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400658 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400658 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429799,373573,220026,27710,52696,11,1020342,112022,719028,592268,621901,563476,353578,938614,812429,1047306,894717,754465,1001305,1009098,211494,239038,658303,158955,202247,66303,987531,223319,3885,920636,279883,735210,639702,758317,631291,814319,650127,685593,377245,843107,1039692,255291,451421,170690,517192,740947,192959,122875,1009281,89529,789767,769346,851625,411885,630665,530518,490133,522974,281230,720177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]