SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42545 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42545 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508056,925584,653130,276398,879795,921485,282444,210609,586208,768876,87560,439668,183786,103696,458162,1004345,304862,627775,83407,51109,48493,519085,901474,759718,73845,366488,706481,470040,210951,20138,822037,256185,310918,798684,498483,791890,10387,352218,291996,954077,386959,244951,22658,738571,175322,668560,802889,394219,676573,523390,27345,766330,390674,778766,142477,283005,451685,244219,246880,212722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]