SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914189 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914189 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856206,805714,284614,971449,576529,1556,112246,409916,906481,508699,465162,921803,956620,1039995,1033061,77721,343912,426279,875250,935873,391668,839462,926453,1045102,872608,498130,501471,362527,36736,1007067,878252,641416,157192,600298,801699,542942,124565,27466,475313,181798,268799,175965,942623,1048509,373748,262721,765122,293546,756185,921910,999051,503100,866238,772439,634984,370193,729423,461670,759436,643369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]