SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555513 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555513 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370073,575992,635856,155793,610394,814707,483571,148751,562112,216846,71203,271140,605793,852562,129590,534061,929253,866338,657832,375500,377600,973588,807147,405124,383207,356808,197896,77528,359854,967367,12366,468861,677309,854433,271072,923564,988087,469183,209440,655583,761890,1023855,479107,331929,11885,688867,658406,420196,456423,357182,976222,199991,777293,993870,706625,591631,644797,397808,425522,690978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]