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` = 848013 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 848013 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596830,686046,797370,882874,699228,565246,596629,792395,714877,384456,521343,563302,363194,1022868,544483,700734,382318,1000461,1031031,418778,302156,334118,185253,518854,749611,557114,193658,82147,788592,407692,902864,325444,938651,691434,377925,234938,530706,154340,903830,17932,567898,500200,773288,801475,544902,170236,1673,128373,272888,830924,880821,51787,50875,832938,342711,401642,372434,305868,441890,520813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 848013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 848013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]