SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038010 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038010 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842298,623542,699904,84215,1002225,250445,798871,73511,303042,247896,865331,712788,535800,700981,657125,466512,183006,810875,975115,336086,471946,353895,873931,226681,208298,669793,966569,791119,570919,335366,12360,260353,791791,47614,832751,7855,217539,175181,371151,598123,81360,372675,651287,321714,143527,731480,146140,690994,545557,996641,808340,844652,531268,228654,782613,617766,836564,858856,735279,861238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]