SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027188 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027188 [ RunTime:0.003031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510907,379151,779549,373194,588763,11473,736239,392774,171425,249877,471142,399355,117932,772681,913207,230517,2560,54364,304388,451478,529730,159509,922350,96871,790542,403333,406365,582081,810843,147475,569834,92685,498290,929871,414808,893663,548184,1933,90542,877137,521190,957861,560667,295963,933896,618752,806149,308762,145304,271122,206660,418951,214300,749132,829521,609579,655555,972275,119156,791196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]