SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030073 LIMIT 1 [ RunTime:0.003908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030073 [ RunTime:0.002531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8230,388282,824717,488515,833797,388806,628301,800427,242621,267638,840659,213130,1014331,1008865,811843,995756,825936,883798,8983,321678,377288,404562,676736,612321,986692,100566,673569,1003853,220811,153855,820133,1010130,104508,747118,579119,690695,936269,456988,280468,320226,1044904,475372,523966,316994,467501,506032,422400,717856,318821,1021179,187405,34108,206544,953835,71303,614296,453792,707403,700854,59201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]