SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 135471 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 135471 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408038,130704,109299,167102,901518,936962,202283,451669,108678,70026,606598,265182,497073,156879,438810,214703,557873,1042020,595287,404753,900689,245784,267016,939791,418479,861983,635954,24552,192227,565765,342831,195183,819991,939552,274251,617136,818958,103426,388451,966209,481548,817231,526168,490394,1006128,304741,381080,769158,926066,836923,188915,351703,911811,1007235,553449,248917,358161,636647,608912,1031940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 135471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 135471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]