SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 950012 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 950012 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540693,200269,784722,253971,29129,710107,949031,1028792,456739,705214,970606,1026357,372856,358611,916286,490972,913750,222718,30359,489002,1007780,1038461,874465,212359,741900,145812,849862,156443,421512,870403,183456,1018979,104889,791977,624935,497630,730848,597098,440936,657645,494141,213162,557520,674420,658042,487279,270325,710524,770812,670945,44969,402796,353933,795981,1028116,191333,448106,916841,215018,698458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 950012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 950012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002691s ]