SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022529 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022529 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795345,74672,729998,419964,167821,1003666,491353,1006777,964277,813024,629389,122246,1990,169309,532746,371271,264584,118388,776469,428378,786711,939697,653810,375664,410163,909153,310167,649490,73954,696038,49827,638010,418484,592132,967073,56843,599550,251857,231358,515199,86236,158563,340881,53493,984792,49819,546411,928134,303370,803391,822807,114105,168165,760592,457952,416472,928177,259724,150291,1008672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002750s ]