SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154896 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154896 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410118,879305,628874,861680,169488,573894,122854,931539,682989,579119,986213,107802,987364,642270,774657,273389,323392,592156,639272,932365,758251,880442,280679,23193,96035,228868,1002124,889574,708890,484215,673362,442239,558721,991688,67883,697134,361194,799277,238514,404026,936128,694529,409305,987883,274839,74405,393760,318528,24825,1004059,347015,96503,28806,293164,928143,698137,136629,754508,854807,990046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]