SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401996 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401996 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153763,732745,97712,821246,777922,492350,526148,597161,354831,747321,701367,919674,141437,500049,444539,68360,947598,229960,40995,678625,680439,993874,256600,446404,318652,528603,14951,503845,876764,1043335,175183,948028,703735,152664,1035173,790562,395480,691442,710490,781204,572612,312847,63178,441320,551062,302084,414762,1031220,274615,31582,464905,959167,153846,474776,157352,706241,566470,338765,488872,710847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]