SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447096 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447096 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569111,876053,262040,361071,964753,803066,372517,702894,136486,179847,613282,786494,992445,155849,48879,516943,580281,90005,730535,754177,9268,528175,386674,36816,997094,641380,148295,1040519,943097,909458,647869,581573,780562,101335,464298,419666,980911,840816,85978,565666,813327,982025,477566,1038572,260145,63578,454840,1035528,36287,49383,107572,386413,758460,48706,733549,912909,457807,275399,858155,876234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]