SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802981 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802981 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228019,89142,703938,923775,723252,274461,427870,430268,260503,325595,667398,80500,1007978,203924,979182,488675,973859,243300,425594,160133,572682,662609,546615,890400,85976,594313,764537,465983,295073,620099,803927,340705,38329,239943,801355,1001157,463091,328796,1017201,593394,228897,166925,264292,293479,141025,114360,32012,301664,69862,638275,828999,1002639,306032,259506,558472,591233,427050,403720,177783,157707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]