SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 126800 LIMIT 1 [ RunTime:0.001423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 126800 [ RunTime:0.004242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451845,478412,497714,363571,765761,999675,161167,461713,953589,796454,341482,1040553,101094,1025583,320918,149932,24819,532079,408358,1029650,732679,648013,729185,572433,60041,545608,398010,327786,301920,242921,647383,112979,814345,1024692,90434,535359,892152,222490,2342,876268,960050,528820,252112,678651,624538,120070,191841,745210,372064,707534,508694,1015096,999216,132129,967183,635428,786354,218006,712747,992875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 126800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 126800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]