SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451580 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451580 [ RunTime:0.002920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586745,777911,11020,925183,721318,374104,522479,250119,790183,999821,480445,294251,410820,689068,820398,278697,6307,31329,829419,361855,8242,753813,918053,262365,425533,114422,267390,648088,126021,466330,507946,528098,286695,394918,934348,998428,533039,154138,440327,244551,24777,436577,389223,530980,183147,1002535,227957,446241,799401,918186,827165,556540,1017360,760939,1045502,240029,639782,827819,418109,188885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]