SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016792 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016792 [ RunTime:0.003079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113587,724820,342597,228586,127144,847095,854004,1041321,894333,15918,393076,456345,660880,827183,90581,692313,191278,318151,89902,857789,1013678,470997,496236,271681,972255,778883,101977,212952,65735,378873,665217,951788,953362,510054,635344,722952,531803,662065,822585,1031687,485468,961986,362905,411609,864251,23728,576053,874546,677650,993688,169502,133856,930984,917166,238890,749614,754801,65480,824205,1043096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016792 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016792 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]