SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488648 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488648 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816967,225668,546260,1016635,972660,629218,533673,627133,286250,115826,124703,956199,178856,86734,915763,782601,142906,873604,938434,878629,95883,300989,997837,481211,480717,292596,264267,490787,475173,457029,378333,84332,595295,316541,258453,561,434913,1483,358511,744890,697392,535289,739801,238007,530766,846486,210620,923773,934316,333763,517339,613242,496368,765968,769335,331279,529190,174822,996245,165039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]