SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406986 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406986 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130853,1005692,252420,498825,509528,986448,942251,582888,45018,622036,849336,410164,866503,555926,888139,923467,785523,628397,1000731,505865,225582,604289,881679,601249,274841,429180,307471,956195,687840,930368,325437,185945,111779,780683,768289,790363,886266,145831,875437,85673,929086,725284,669487,508799,184811,833207,743053,902451,535497,624006,889368,327657,60684,610041,376316,530456,463335,826525,573578,293449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000922s ]