SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411698 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411698 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548025,835815,983511,285212,365762,361208,269709,619100,975503,1014745,557902,42980,832029,666792,567004,834817,270941,965389,137476,504873,826344,904809,811122,1020171,815203,518905,405236,355084,861189,729211,199421,202053,1030213,731917,558278,159202,911696,767399,238564,415191,251099,138092,956267,804081,618301,138130,181544,1000115,332569,618562,976947,734447,143327,706095,49872,955289,925680,429362,195218,505595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001179s ]