SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414214 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414214 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930917,846651,833619,862470,134871,390864,900881,1041184,210543,702284,62507,91494,911126,844369,990519,933256,154211,858659,115563,448028,289265,606853,719689,142246,611053,731428,558108,812441,1027735,682571,347362,573110,382448,205655,862523,394162,496991,219854,797802,43836,996506,84376,386333,325061,676388,629600,159290,629149,580359,921699,480473,571274,225455,579021,913821,598137,346857,367916,207999,16895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]