SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530529 LIMIT 1 [ RunTime:0.000974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530529 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771209,694846,1040188,850267,866994,101187,897792,896251,873726,870053,30779,979117,455890,84158,772723,493389,392363,94063,35202,954988,636924,232477,56868,37817,787142,782508,418230,951950,994221,857992,487886,1024748,250575,708285,685005,1041861,591142,753543,218575,1046964,262917,456792,551044,497480,835977,853460,459939,76726,576337,574427,824074,892272,1024660,274601,2546,112072,936841,615968,943129,1022878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]