SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430891 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430891 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602587,89460,243214,539571,124893,734513,302984,414527,553278,143005,279987,251816,631642,25265,480843,738714,814663,884151,991241,107157,704432,16389,173353,448514,433740,671843,500604,935518,202517,114496,615872,407460,143566,597886,293783,422675,57571,413254,1044148,148824,943423,352873,616491,441584,836305,1029293,337049,452839,679237,949056,804092,903808,384378,247296,491263,925765,581531,724903,486329,71321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]