SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498105 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498105 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463317,659424,764145,606099,719548,271127,227661,619790,292289,891498,741292,968218,775591,191398,420941,197505,284182,128871,619789,1030499,711892,251728,930559,174670,919243,684011,823111,491476,37977,275595,468824,203820,643841,551268,546098,424504,926886,142570,57053,193150,907202,138035,499782,101987,687873,770809,239822,173871,303821,553910,734112,458894,237063,724818,93263,269243,236915,546401,838829,689235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002182s ]