SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453223 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453223 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723550,428077,902577,669323,715099,295211,248110,215126,35357,248413,962978,67677,869208,44534,251809,324262,387841,839754,105003,776956,911285,817816,780612,924075,122957,197603,973031,259081,165899,759954,396330,304883,187694,249359,855777,146218,606326,775499,297204,776832,152558,379719,916748,654269,565175,603465,218723,23902,294678,21565,532763,148586,255783,247736,408754,453409,994016,405955,896605,232752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]