SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514440 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514440 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811998,480656,309908,405952,684842,959994,982230,964171,730613,440248,679584,877816,178337,137526,38598,244429,355196,834168,133736,166338,195135,658142,411780,962571,498560,647568,407639,645626,214782,993955,1040989,48601,851547,324341,235834,1000761,716930,322738,60375,74997,181319,739082,227790,207102,297223,571968,119016,600931,929193,587015,520504,982935,626361,258648,1015876,215541,821241,61131,26634,301698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]