SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583582 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583582 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385448,551356,296361,184467,786573,562903,849980,85548,909248,386965,410988,418256,817109,367630,1027804,241701,301572,850788,248380,955837,175894,369547,610013,243171,922587,850654,466664,316675,527949,108371,368923,55043,66568,207189,1020359,934857,87464,855936,554006,870881,779658,448788,876701,651709,625097,922877,631340,264789,779072,958277,380146,996805,999544,694601,574805,849678,893768,400006,278058,68041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]