SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326640 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326640 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721671,518554,570887,630956,638381,60650,1000441,985053,1029472,330178,197100,147567,44632,394229,659400,597164,565535,921148,129982,730553,950789,168831,587497,768364,555149,63275,229072,553650,682219,376050,47029,386956,829970,750382,758919,391245,417027,857774,891638,890537,970890,518230,166995,704898,1035397,499352,851460,904422,483561,1029430,650342,70809,267721,603435,400764,407187,128075,670957,304282,159856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001874s ]