SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505953 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505953 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456296,702146,397693,845076,508927,992259,559974,1029390,162845,524997,863164,357854,841845,188741,450378,654447,611489,16986,648436,614118,964465,903589,590327,515707,1010657,842675,816270,707650,22142,985188,655329,198597,218236,291070,270793,795176,768153,754011,990008,469634,484840,303417,376387,625605,101831,844373,377523,491755,876365,603112,771563,1004838,880005,557925,121880,973226,333286,859028,1023020,416473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]