SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154813 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154813 [ RunTime:0.003567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532663,1032486,855411,811542,789650,891432,783727,286762,273826,216125,852929,779263,331877,930286,477702,910390,258127,309225,119106,833645,325754,1036763,582878,103272,731442,754838,359677,304105,395535,603909,765541,687332,775541,671305,488407,243899,629543,161637,554207,889157,424524,712669,280074,416660,333061,14828,800194,752664,117837,510978,337753,676582,644871,598198,627813,1027508,550107,379477,645158,971202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001367s ]