SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1980 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1980 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442384,910813,616202,12865,285970,887491,975903,513100,841632,588491,190694,565578,307141,482744,640389,102867,1035072,361267,412129,635678,580779,652751,505696,313106,58833,128731,319301,313889,515773,796499,380012,944250,915337,903480,859418,684283,378332,970004,786574,823058,531392,150653,997028,671041,357226,827108,525616,13392,470580,189220,529065,821972,882045,377614,99079,1003017,16482,464177,83992,363410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]