SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296043 LIMIT 1 [ RunTime:0.004124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296043 [ RunTime:0.005131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575386,707468,843729,473614,847507,1017021,786871,406143,495338,472984,255701,503325,633457,689432,78333,320937,946071,4777,158481,301930,639643,460613,416469,608171,356284,905847,970746,901919,85659,316751,329228,713262,738907,784661,283659,340941,935894,682447,73617,993630,651493,183914,625176,455196,306170,518965,590548,366599,191769,405850,38513,824570,650228,367573,262646,1031151,224821,939604,127216,689429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]