SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429695 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429695 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718123,848452,188229,490816,1033813,200351,239423,779321,563155,414250,253276,168305,11812,914334,508717,895398,523601,704750,917036,145015,389605,1020827,570700,148780,152224,1011598,99722,706310,389395,949767,405558,933199,610069,968857,791111,647328,597467,384010,521561,409308,439674,574742,896602,816085,312946,108638,609538,755792,807672,677106,982758,630844,533076,685804,754169,57142,760055,295476,993839,175918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429695 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429695 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]