SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414058 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414058 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838533,867383,850284,839715,753837,993199,249840,891271,499993,191064,578893,744961,343428,310009,920252,162998,968726,542435,165914,1000335,591098,729712,552886,265348,500237,793660,836583,162078,294424,424200,493547,486262,124403,268336,674680,58510,144475,966042,699146,730207,606432,155066,353136,432077,63965,745344,15849,260712,574028,576947,113941,795188,764841,566393,1014469,575707,824177,678724,963636,76758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]