SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981010 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981010 [ RunTime:0.004028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733051,262217,449017,409857,459435,617732,661288,851208,513143,554857,724248,326404,36785,761607,1024272,616650,327468,298778,979678,220421,109581,827449,677514,619874,185127,994733,810563,680420,615449,607763,675653,62447,135434,539082,658575,889346,135550,175425,313119,527742,942847,311856,914452,86082,424679,820894,679930,1005481,504194,312888,359405,284423,849331,500406,759249,214416,166000,117092,716747,241835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]