SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030850 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030850 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031035,270980,551974,753172,283897,290402,909808,577430,909216,624515,628408,720789,19791,772321,825599,586511,174584,694143,606376,634056,715122,330431,294625,790121,209051,1036604,757640,1045603,263050,919084,578391,187239,356734,1013300,265666,92012,999611,950102,191199,121197,46483,936919,849481,868265,317919,502589,709270,509104,927916,159561,785106,265668,428521,71451,691190,363475,549949,1004929,629913,334639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]